CREATE TABLE [dbo].[tb_Formularios]
(
[idFormulario] [int] NOT NULL IDENTITY(1, 1),
[Nombre] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Tipo] [int] NOT NULL,
[Movimiento] [int] NULL,
[Contador] [int] NOT NULL,
[Ano] [int] NOT NULL,
[FormatoPDF] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FormatoOnLine] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FormatoEmail] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Formularios] ADD CONSTRAINT [PK_tb_Formularios] PRIMARY KEY NONCLUSTERED  ([idFormulario]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Formularios] WITH NOCHECK ADD CONSTRAINT [FK_tb_Formularios_tb_Movimientos] FOREIGN KEY ([Movimiento]) REFERENCES [dbo].[tb_MovimientosDocentes] ([idMovimiento])
GO
ALTER TABLE [dbo].[tb_Formularios] WITH NOCHECK ADD CONSTRAINT [FK_tb_Formularios_tb_TiposDeFormularios] FOREIGN KEY ([Tipo]) REFERENCES [dbo].[tb_TiposDeFormularios] ([idTipoFormulario])
GO
